Stump the Panel: SharePoint Q&A

I have a need to dynamically add an option to a drop down menu based on the user that is logged in. So far I've been able to add the option based on the user, to add the option to the drop down menu I'm using something similar to the following:

$('<option value="Midwest">Midwest</option>').appendTo('select[title="Test"]');

However, when the user clicks OK to submit the new list item SharePoint gives an 'an unexpected error occured'.

Is doing something like this even possible?

Thanks!

Just adding the value into the DOM won't make it a valid value. You'll need to use the Web Services to add the value to the column itself, and then refresh the dropdown with the right ID value for the control to work.

M.

Hello Marc.
Than you for the solution that you have provided for the cascading dropdown. I have some trouble working with it:can you please guide me where I am going wrong. I follwoed the follwoing steps:
1. Created a list called cities
2. Created another list called countries
3.Created a list called Vacation Plans- which has colums Country(look up from countries list) and City ( choice field, with column - no city selected)
4. Then I created a new item and added a content editor web part ( By default i was not able to edit the newitem.aspx page from browser- so when I opened the page I said http:/mysite/lists/newitem.aspx?toolpaneview=2 - which allowed me to add the content editor webpart).
5.After that I put the follwoing code in the source editor
<script language="javascript" type="text/javascript" src="http://moss.litwareinc.com/Cascade/jquery-1.3.2.min.js"></script>
<script language="javascript" type="text/javascript" src="http://moss.litwareinc.com/Cascade/jquery.SPServices-0.5.6.min.js"></script>
<script language="javascript" type="text/javascript">
$(document).ready(function() {
$().SPServices.SPCascadeDropdowns({
relationshipList: "Cities",
relationshipListParentColumn: "Country",
relationshipListChildColumn: "Title",
parentColumn: "Country",
childColumn: "City"'
debug: true

});

});
</script>
When i hit on Ok it saves teh code. when I go back to teh new page and say new item, and select a county say United states- i get the options under that which is absoultely firn, bt when i hit on ok to save it I get the error -
"An unexpected error has occurred.
Troubleshoot issues with Windows SharePoint Services. "

I do not understand the issue here. I am kind of new bie to sharepoint. Can you please help me out with this?

Thank you very much.

The City column needs to be a Lookup column into the Cities list. The Cities list also needs to contain the relationships between the City and Country. Hopefully it's a simple as that.

M.

Hi Marc,

Sorry to post in this thread... no one is replying so thought to post here

I am using wss 3.0 Room and Equipment bookings Template provided by Microsoft.

If u see the template under Reservations/Availability.aspx a diagramatic or Grid view is displayed with the resources in a column and time durations for the resources in different columns.

When we book a resource a purple color image is displayed to the corresponding Resource and the time.

My Requirement: want to show a tool tip or display text on the colored zone(purple color) or reserved zone as "Reserved By: @user" that who has actually reserved that.

As soon as i try to display some thing title={@author} or title={@Reserved by}.....the tool tip shows the user that has created a "Resource" but not who has actually "Reserved" or the user who created item under "Reservations" List

Please help me on this.

Thanks in advance

Jam:

This one may be as simple as your spelling of the column name(s).
title={@author} -> Should be -> title={@Author}
title={@Reserved by} -> Should *probably* be -> title={@Reserved_x0020_by}

Unfortunately, that will add the full HTML blob about the user to the tooltip. You actually need to parse out the person's name from the blob. See the GetUserName in my SPXSLT Codeplex Project.

M.

Reserved By is just the Created By column renamed, so it should be @Author.

Please dont hijack threads as it makes for finding solutions for others difficult.

Thanks for the reply Marc/Eric
Im sorry again for breaking the thread

yeah i understand that i need to give something like title="{@Author}" or title="{@Reserved_x0020_by}" but in tooltip it is showing the author of the Resource but not the Reservation..... u will get to know once u see the template of Room and Equipment Reservations template.....

Thanks for your support

Thanks Marc - for you Support. Its working now.